/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package cn.net.greenet.logmanage.servlet;

import cn.net.greenet.logmanage.logic.LogManageService;
import cn.net.greenet.logmanage.logic.bean.AckInComingLogBean;
import cn.net.greenet.logmanage.logic.bean.MessageOutGoingLogBean;
import cn.net.greenet.logmanage.logic.common.DBUtils;
import com.j256.ormlite.support.ConnectionSource;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.Date;
import java.util.Iterator;
import java.util.Map;
import java.util.Map.Entry;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

/**
 *
 * @author dongqiang
 */
@WebServlet(name = "QueryStrategySend", urlPatterns = {"/log/strategy_send_query"})
public class QueryStrategySend extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("application/json;charset=UTF-8");
        PrintWriter out = response.getWriter();

        // 必选参数
        String deviceId = request.getParameter("id");
        long startTime = parseTime(request.getParameter("startTime"));
        long endTime = parseTime(request.getParameter("endTime"));
        int pageCount = Integer.parseInt(request.getParameter("pageCount"));
        int page = Integer.parseInt(request.getParameter("page"));

        // 可选参数
        String MessageType = request.getParameter("MessageType");
        String MessageNo = request.getParameter("MessageNo");
        String ip = request.getParameter("ip"); // DPI设备的IP地址
        String rck_flag = request.getParameter("rck_flag");

        ConnectionSource conn = null;
        try {
            JSONArray outputData = new JSONArray();
            conn = DBUtils.getConnectionSource();
            LogManageService service = new LogManageService(conn);
            Map<MessageOutGoingLogBean, AckInComingLogBean> logs = null;
            if (deviceId != null) {
                int id = Integer.parseInt(deviceId);
                logs = service.getStrategySendLogByDeviceId(id, startTime, endTime, pageCount, page, MessageType, MessageNo);
            } else if (ip != null) {
                logs = service.getStrategySendLogByDeviceIP(ip, startTime, endTime, pageCount, page, MessageType, MessageNo);
            } else {
                throw new Exception("parameter id or ip are not provided");
            }
            if (logs != null) {
                Iterator<Entry<MessageOutGoingLogBean, AckInComingLogBean>> it = logs.entrySet().iterator();
                while (it.hasNext()) {
                    Entry<MessageOutGoingLogBean, AckInComingLogBean> entry = it.next();
                    MessageOutGoingLogBean message = entry.getKey();
                    AckInComingLogBean ack = entry.getValue();

                    JSONObject o = new JSONObject();
                    o.put("id", message.getDpi().getId());
                    o.put("MessageType", message.getMessageType());
                    o.put("MessageNo", message.getMessageNo());
                    o.put("MessageSequenNo", message.getMessageSequenceNo());
                    o.put("MessageSerialNo", message.getMessageSerialNo());
                    o.put("MessageAckFlag", ack == null ? 0 : 1);
                    o.put("name", message.getDpi().getName());
                    if (ack != null) {
                        o.put("rckReceiveTime", ack.getReceiveTime().getTime() / 1000);
                    }
                    o.put("sendStartTime", message.getSendStartTime().getTime() / 1000);
                    o.put("sendStopTime", message.getSendStopTime().getTime() / 1000);
                    outputData.add(o);
                }
            }
            out.print(outputData.toString());
        } catch (Exception ex) {
            Logger.getLogger(QueryStrategySend.class.getName()).log(Level.SEVERE, null, ex);
            out.print("[]");
        } finally {
            DBUtils.closeConnectionSource(conn);
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

    /**
     * 解析时间
     * @param parameter Linux时间戳字符串
     * @return 
     */
    private long parseTime(String parameter) {
        return Long.parseLong(parameter) * 1000;
    }
}
